TillOperatorAssignment

Entity Definition

Logical Name : TillOperatorAssignment
Physical Name : CO_ASGMT_OPR_TL

A permanent or temporary assignment of a Till to a particular OperatorID, recording which Operators had access to the Till for a particular period of time.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
AssignmentStartTransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_SRT IdentityUUID char(32) SignOnTransaction(TR_SGN_ON)
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) TillOperatorAssignmentTransaction(TR_ASGMT_OPR_TL)
TillID (FK)(PK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer Till(AS_TL)
OperatorID (FK)(PK) A unique, automatically assigned number used to identify a workstation OPERATOR. ID_OPR Identity integer Operator(PA_OPR)
AssignmentEndTransactionID (FK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN_END IdentityUUID char(32) SignOffTransaction(TR_SGN_OFF)

Relationships

Parent Entity Verb Phrase Child Entity
SignOnTransaction starts TillOperatorAssignment
TillOperatorAssignmentTransaction creates TillOperatorAssignment
Operator is assigned TillOperatorAssignment
Till is assigned TillOperatorAssignment
SignOffTransaction ends TillOperatorAssignment

Logical Views containing TillOperatorAssignment

Logical View
Logical 02410 - Control Transaction - Sign On Off View
Logical 02420 - Control Transaction - Till Movement View
Logical 02450 - Control Transaction - Drawer Limit
Logical 02500 - Tender Control Transaction - Macro View
Logical 02520 - Tender Control Transaction - Settlement View
Logical 03150 - Reporting - Store Operations - Operator View
Logical 03160 - Reporting - Store Operations - Till View
Logical 10120 - Enterprise - Location, WkStn, Operator, Till
Logical 11160 - Worker - Reporting View